Problem Note 42136: SAS® Add-In for Microsoft Office might not work as expected on a Microsoft Excel worksheet embedded within Microsoft Word or Microsoft PowerPoint
 |  |  |  |
When you attempt to use SAS Add-In functionality on a Microsoft Excel table or spreadsheet that is embedded inside a Microsoft Word document or Microsoft PowerPoint presentation, the SAS Add-In might not be loaded in the embedded application. This behavior was implemented in order to prevent exceptions that can occur when the application is embedded. To turn the SAS Add-in functionality back on, follow these steps:
- Close all Microsoft Office applications on the client machine.
- Create a file named
SAS.OfficeAddin.dll.configand place it in the following location on the client machine:<drive>:\Program Files\SAS\Add-InForMicrosoftOffice\4.2
Note: This instruction assumes the SAS Add-In was installed in the default location. If you didn't install the application in the default location, place the configuration file in the directory where you installed the SAS Add-In.
- Edit
SAS.OfficeAddin.dll.config, and add the following lines: - Save the file.
<configuration>
<assemblySettings>
<add key="LoadWhenEmbedded" value="true"/>
</assemblySettings>
</configuration>
If you have an embedded spreadsheet, and you are still seeing exceptions, refer to SAS Note 39385 for the instructions to prevent the SAS Add-In from loading.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-01-31 15:49:16 |
| Date Created: | 2011-01-20 14:44:29 |